﻿/*------------------插入字典类型dit_type-------------*/
INSERT into dic_type values('HYLX',0,'行业类型','');
INSERT into dic_type values('XMLX',0,'项目类型','');
INSERT into dic_type values('XMSZD',0,'项目所在地','');
INSERT into dic_type values('XMSPBM',0,'项目审批部门','');
INSERT into dic_type values('XMLY',0,'项目来源','');
INSERT into dic_type values('XMJD',0,'项目进度','');
INSERT into dic_type values('DKFS',0,'到款方式','');
INSERT into dic_type values('HTQDZT',0,'合同签订主体','');
INSERT into dic_type values('HTZT',0,'合同状态','');
INSERT into dic_type values('KPZT',0,'开票状态','');
INSERT into dic_type values('DKZT',0,'到款状态','');
INSERT into dic_type values('GDZT',0,'归档状态','');
INSERT into dic_type values('BGYP',0,'办公用品','');
INSERT into dic_type values('KCJS',0,'扣除基数','');
INSERT into dic_type values('JSDW',0,'建设单位','');
INSERT into dic_type values('XMYQSPZT',0,'项目延期审批状态','');
INSERT into dic_type values('TJXS',0,'提奖系数','');
commit;

/*------------------插入字典项-------------*/
/*------------------插入行业类型dic_item-------------*/
INSERT into dic_item values('HYLX',1,'交通运输','交通运输');
INSERT into dic_item values('HYLX',2,'冶金机电','冶金机电');
INSERT into dic_item values('HYLX',3,'社会区域','社会区域');
INSERT into dic_item values('HYLX',4,'农林水利','农林水利');
commit;
/*------------------插入项目类型dic_item-------------*/
INSERT into dic_item values('XMLX',1,'报告书','');
INSERT into dic_item values('XMLX',2,'报告表（敏感）','');
INSERT into dic_item values('XMLX',3,'报告表（不敏感）','');
INSERT into dic_item values('XMLX',4,'登记表','');
INSERT into dic_item values('XMLX',5,'初评','');
INSERT into dic_item values('XMLX',6,'后评价','');
INSERT into dic_item values('XMLX',7,'补充评价','');
INSERT into dic_item values('XMLX',8,'退役评价','');
INSERT into dic_item values('XMLX',9,'规划','');
INSERT into dic_item values('XMLX',10,'课题','');
commit;
/*------------------插入项目所在地dic_item-------------*/
INSERT into dic_item values('XMSZD',1,'杭州','');
INSERT into dic_item values('XMSZD',2,'上城','');
INSERT into dic_item values('XMSZD',3,'下城','');
INSERT into dic_item values('XMSZD',4,'拱墅','');
INSERT into dic_item values('XMSZD',5,'江干','');
INSERT into dic_item values('XMSZD',6,'西湖','');
INSERT into dic_item values('XMSZD',7,'高新（滨江）','');
INSERT into dic_item values('XMSZD',8,'萧山','');
INSERT into dic_item values('XMSZD',9,'余杭','');
INSERT into dic_item values('XMSZD',10,'下沙','');
INSERT into dic_item values('XMSZD',11,'其他','');
commit;
/*------------------插入项目审批部门dic_item-------------*/
INSERT into dic_item values('XMSPBM',1,'市局','');
INSERT into dic_item values('XMSPBM',2,'上城','');
INSERT into dic_item values('XMSPBM',3,'下城','');
INSERT into dic_item values('XMSPBM',4,'拱墅','');
INSERT into dic_item values('XMSPBM',5,'江干','');
INSERT into dic_item values('XMSPBM',6,'西湖','');
INSERT into dic_item values('XMSPBM',7,'高新（滨江）','');
INSERT into dic_item values('XMSPBM',8,'萧山','');
INSERT into dic_item values('XMSPBM',9,'余杭','');
INSERT into dic_item values('XMSPBM',10,'下沙','');
INSERT into dic_item values('XMSPBM',11,'其他','');
INSERT into dic_item values('XMSPBM',12,'省厅','');
commit;
/*------------------插入项目来源dic_item-------------*/
INSERT into dic_item values('XMLY',1,'市场','');
commit;
/*------------------插入项目进度dic_item-------------*/
INSERT into dic_item values('XMJD',1,'收集资料','');
INSERT into dic_item values('XMJD',2,'现场勘查','');
INSERT into dic_item values('XMJD',3,'编写报告','');
INSERT into dic_item values('XMJD',4,'第一次公示','');
INSERT into dic_item values('XMJD',5,'第二次公示','');
INSERT into dic_item values('XMJD',6,'一审','');
INSERT into dic_item values('XMJD',7,'二审','');
INSERT into dic_item values('XMJD',8,'三审','');
INSERT into dic_item values('XMJD',9,'专家评审','');
INSERT into dic_item values('XMJD',10,'报告修改','');
INSERT into dic_item values('XMJD',11,'进件审批','');
INSERT into dic_item values('XMJD',12,'项目暂停','');
INSERT into dic_item values('XMJD',13,'审批完成','');
INSERT into dic_item values('XMJD',14,'项目归档','');
commit;
/*------------------插入项目到款方式dic_item-------------*/
INSERT into dic_item values('DKFS',1,'现金','');
INSERT into dic_item values('DKFS',2,'汇款','');
commit;
/*------------------插入合同签订主体dic_item-------------*/
INSERT into dic_item values('HTQDZT',1,'院','');
INSERT into dic_item values('HTQDZT',2,'公司','');
commit;
/*------------------插入合同状态dic_item-------------*/
INSERT into dic_item values('HTZT',1,'已签订','');
INSERT into dic_item values('HTZT',2,'未签订','');
commit;
/*------------------插入开票状态dic_item-------------*/
INSERT into dic_item values('KPZT',1,'已开票','');
INSERT into dic_item values('KPZT',2,'未开票','');
commit;
/*------------------插入到款状态dic_item-------------*/
INSERT into dic_item values('DKZT',1,'已到款','');
INSERT into dic_item values('DKZT',2,'未到款','');
commit;
/*------------------插入归档状态dic_item-------------*/
INSERT into dic_item values('GDZT',1,'已归档','');
INSERT into dic_item values('GDZT',2,'未归档','');
commit;
/*------------------插入办公用品dic_item-------------*/
INSERT into dic_item values('BGYP',1,'A4纸','');
INSERT into dic_item values('BGYP',2,'墨盒','');
commit;
/*------------------插入扣除基数dic_item-------------*/
INSERT into dic_item values('KCJS',1,'70000','');
commit;
/*------------------插入建设单位dic_item-------------*/
INSERT into dic_item values('JSDW',1,'杭州市国土局土地储备中心','');
commit;
/*------------------插入项目延期审批状态dic_item-------------*/
INSERT into dic_item values('XMYQSPZT',1,'批准','');
INSERT into dic_item values('XMYQSPZT',2,'否决','');
commit;
/*------------------插入提奖系数dic_item-------------*/
INSERT into dic_item values('TJXS',1,0.15,'报告书');
INSERT into dic_item values('TJXS',2,0.15,'报告表（敏感）');
INSERT into dic_item values('TJXS',3,0.15,'报告表（不敏感）');
INSERT into dic_item values('TJXS',4,0.15,'登记表');
INSERT into dic_item values('TJXS',5,0.15,'初评');
INSERT into dic_item values('TJXS',6,0.15,'后评价');
INSERT into dic_item values('TJXS',7,0.15,'补充评价');
INSERT into dic_item values('TJXS',8,0.15,'退役评价');
INSERT into dic_item values('TJXS',9,0.15,'规划');
INSERT into dic_item values('TJXS',10,0.15,'课题');
commit;

